import os,sys

current_dir = os.path.dirname(os.path.abspath(__file__))  
current_parent=os.path.dirname(current_dir)
sys.path.append(os.path.join(current_parent))

from pylibs import SqlHelper


# 测试 SqlHelper

def main1():

    db1 = SqlHelper.connect()

    res1 = SqlHelper.fetch_all('select * from t_book1 where id > %(id1)s', {"id1": 50})

    print(res1)

    # 结果见附件 hsip1.xlsx
    

if __name__ == '__main__':  
    main1()

